How to: Change a field name in the query design grid.
Solution:
Click in the 'Field' cell, click on the arrow and select the desired field name from the drop-down list.
1) If the Database window is not active, activate the Database window.
2) Click the 'Queries' tab in the Database window.
Queries tab
3) Select the desired query. (The query is highlighted.)
4) Click 'Design'. (The query appears in query design view.)
5) Click in the 'Field' cell. (A down arrow appears in the right-hand corner.)
6) Click on the arrow. (A drop-down list appears.)
7) Select the desired field name from the drop-down list.
